UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZT4g4Xdd6U74X6RsbNcGaM11WxGiG41YTEmKVlR4y78='
WHERE
key_id = 'd07b28bdf689e0738302716ca22aff16ce0a6afa8517cfea0d52b0d97fd92fe5'
AND (
token = 'ZT4g4Xdd6U74X6RsbNcGaM11WxGiG41YTEmKVlR4y78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)