UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAl/EpH75QhyfdNzJ/APLKIJjtma4QDHlWB0PSvukXc='
WHERE
key_id = 'c8872abea8d96d2177250b83d120f3710019ea5143b42a2c278c207361cc3bc9'
AND (
token = 'HAl/EpH75QhyfdNzJ/APLKIJjtma4QDHlWB0PSvukXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)