UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZxPD55c0sT2hKEyk3gBKaleHeSqF4VNRo3cFwN9RQ/4='
WHERE
key_id = '316c187d07daed43324a9c2916a31de785553a7efc4fd197d8c146f837864b80'
AND (
token = 'ZxPD55c0sT2hKEyk3gBKaleHeSqF4VNRo3cFwN9RQ/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)