UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOELnR3ud24CtPvfYL97CKHirR7GtSWMPrExUkh2MjQ='
WHERE
key_id = '81671a2e20f8b14e94fd2c5d8185f43f1751ca42f1d3af71d46204940acb5d43'
AND (
token = 'HOELnR3ud24CtPvfYL97CKHirR7GtSWMPrExUkh2MjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)