UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zlYQtw/Dt1cYrmajCpITUQVcqrBRCoUuz7LTDcgoHvo='
WHERE
key_id = '93a6e20b41b125555364eb6339087075a8a04e711928c1a83266df3b06b8eeac'
AND (
token = 'zlYQtw/Dt1cYrmajCpITUQVcqrBRCoUuz7LTDcgoHvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)