UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JnIzph9KAAOI5pCl8AYmBgWk/zGzSlJDry7lwcmKzdw='
WHERE
key_id = 'b97f83a06f8c23d7ad1eb20b543b8672029921a8d7440bf3481c89728638a838'
AND (
token = 'JnIzph9KAAOI5pCl8AYmBgWk/zGzSlJDry7lwcmKzdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)