UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qFHZEyJN2soh9QAALxAmP8Hx2apeXzrVfNBIsHBuAAU='
WHERE
key_id = '1c470abba4b4108cedfa359445b57d6596373ad3e3d8af37c4a526d001027f7f'
AND (
token = 'qFHZEyJN2soh9QAALxAmP8Hx2apeXzrVfNBIsHBuAAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)