UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tsB6WDgBOuUZyuhON4DGCWOlqtogDQt6Yuct/1Qhxok='
WHERE
key_id = '8aca123a89121ba5b8522de2875502240be4b76642276b9b1b1ee2a48cf91fca'
AND (
token = 'tsB6WDgBOuUZyuhON4DGCWOlqtogDQt6Yuct/1Qhxok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)