UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xk2kIwGdcw32YFE9ZQFVn1ywCo87ul/6B1M1VMK8nA8='
WHERE
key_id = '122fd1bc2fade52eaedb2907729a5389191dcf42c49e811eab3981f03b93d1cd'
AND (
token = 'xk2kIwGdcw32YFE9ZQFVn1ywCo87ul/6B1M1VMK8nA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)