UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HkHOX+v+gS7jRgeSmYswm/J3B5dad+BHmIRT20c+rrE='
WHERE
key_id = '561963c568af7eaa922bbbc272eb2916a155befaffd70b2f20d381ced2ec838f'
AND (
token = 'HkHOX+v+gS7jRgeSmYswm/J3B5dad+BHmIRT20c+rrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)