UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HG4Zv1qjHee6Pcj0v19qhHVU+dIeTc6qs8D+2gZ/aqU='
WHERE
key_id = 'd81ff9f0600ddc71b9c669b00346d1f7dd4a1f7cd500fdd8c205d41259a3c7e7'
AND (
token = 'HG4Zv1qjHee6Pcj0v19qhHVU+dIeTc6qs8D+2gZ/aqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)