UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6OSydkSzS2kEzPl8G/J8SrXXbbENV0LUW2c7GxQb7kw='
WHERE
key_id = '8c2841d9c93c4110b3d477268df4ace45fc81c304c74bf00d3d5532ddfccec42'
AND (
token = '6OSydkSzS2kEzPl8G/J8SrXXbbENV0LUW2c7GxQb7kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)