UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'trHXT59UfIwCM4w4Z76RuLldXWw4nFifULNfWx4/aqs='
WHERE
key_id = 'b00f16adf8e9e416689dfeddd31050ccf1eb6a5cd69394423b2754738d8a1c5f'
AND (
token = 'trHXT59UfIwCM4w4Z76RuLldXWw4nFifULNfWx4/aqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)