UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/jBU/PkofYPF4ITr08Rct7gJ8FU6v1Mw01Pf4gf1rJk='
WHERE
key_id = '13ced0047ece62e905409909d410ff416955ca3fc816beb4c73bdf20fba894aa'
AND (
token = '/jBU/PkofYPF4ITr08Rct7gJ8FU6v1Mw01Pf4gf1rJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)