UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BqAYG1ODhsw57r4kSd5R1lCpC2lUEtwsVBL7CU4C8hA='
WHERE
key_id = 'fe38ba4a640c40b3f334f5197a24c14be1f3919c3f261c134d4e6aa956fc2a6d'
AND (
token = 'BqAYG1ODhsw57r4kSd5R1lCpC2lUEtwsVBL7CU4C8hA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)