UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'voUKowMpkXuHOCOf4PaXLvpN6sF5HlcvbpUaEp+35yg='
WHERE
key_id = '05ddc77cc2707d35feb2fdb5a4579f947df2391810595f5641b236caf624b7a6'
AND (
token = 'voUKowMpkXuHOCOf4PaXLvpN6sF5HlcvbpUaEp+35yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)