UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iHmaxS75FvberQaSjnbpcNUon9JxThy3So9izehkPU='
WHERE
key_id = '287e9a10083d9ffe761e1cfabdb344872468b9a87ae8b8340e9be1ce125ab793'
AND (
token = '3iHmaxS75FvberQaSjnbpcNUon9JxThy3So9izehkPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)