UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CShs8Ehr1VzIQdo/sX0MvG4+J2z68bRvjWTkMmK/9E='
WHERE
key_id = 'a18d25ec1ab983af239c975764650b53861c3f100bf3640decdf2edff5516a49'
AND (
token = '/CShs8Ehr1VzIQdo/sX0MvG4+J2z68bRvjWTkMmK/9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)