UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JfjtsscGwPfVaET7uKBOGEsYHfINN+IaD0pxh/vW8OU='
WHERE
key_id = '864a2f726b720a8bd3daa1678ccb26cd39141796da9087253976be001999e03a'
AND (
token = 'JfjtsscGwPfVaET7uKBOGEsYHfINN+IaD0pxh/vW8OU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)