UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nzzeDC6e3WMUHW7INy4DFgdR1I4ImYlEmfBat/xPpA0='
WHERE
key_id = '8b59330f667cae7ff7bc18cfb0a4adab485a75291caa8d7506ff5bec8b4aaf8c'
AND (
token = 'nzzeDC6e3WMUHW7INy4DFgdR1I4ImYlEmfBat/xPpA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)