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