UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDs3rCjCvXQp+SjsvKkF1Esr0xETHSGcovsVk9QU0Qw='
WHERE
key_id = '538b8fce55fcdb926b5afabd2739313def8d7548d776260ae2d48311c248255a'
AND (
token = 'sDs3rCjCvXQp+SjsvKkF1Esr0xETHSGcovsVk9QU0Qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)