UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQgbN1L8SyIZlF3W1q+uLcxEEYyQv64Iq5khkYaw5gg='
WHERE
key_id = '167581c1a453a4b1621ab4ca19db8c622aa135363207061ffcb2ac457a034b6a'
AND (
token = 'xQgbN1L8SyIZlF3W1q+uLcxEEYyQv64Iq5khkYaw5gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)