UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Fm3LHlw2KmfrYLGZgOO2NwZrBLd7KmtNt47WWX+dWcE='
WHERE
key_id = '0ef367c0e8b702ba605de227f359ddfb76928d120c3fa5eb5143f2d144b30d87'
AND (
token = 'Fm3LHlw2KmfrYLGZgOO2NwZrBLd7KmtNt47WWX+dWcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)