UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gyhEXi1yXT9rCJG8msIi43JjMhmLbhC3tX6XJsgmyNw='
WHERE
key_id = '304d48ab31475386b32334f6cc3edbaae49d7146820131d9d88200aad32b94f0'
AND (
token = 'gyhEXi1yXT9rCJG8msIi43JjMhmLbhC3tX6XJsgmyNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)