UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kRZPa3Sj7O3YjyY5V1XFNwIF87gt3polXhFK361Lqk='
WHERE
key_id = '7e519123e79ab5a672af5d601a8136f0a16a3c92d44da81397147daf6bf3393e'
AND (
token = '0kRZPa3Sj7O3YjyY5V1XFNwIF87gt3polXhFK361Lqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)