UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qFwNx+koh7PhMu2Y+n/9LVAqahdHpasyowfdVX7iUo='
WHERE
key_id = 'bcd79c4761eae58d323b634fc5bff9bc376f80c66543a5a389349b26d15b341b'
AND (
token = '9qFwNx+koh7PhMu2Y+n/9LVAqahdHpasyowfdVX7iUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)