UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JEqgXSmX4Ubop6y+kYDPC3z601D0dDOx8ANXX6w0IdY='
WHERE
key_id = '46d4ccb05573a6f0b45712318907804f9249886736ab52dd67d6737d8b5877e1'
AND (
token = 'JEqgXSmX4Ubop6y+kYDPC3z601D0dDOx8ANXX6w0IdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)