UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'igPT6UGkzhy1uFaOQ7m++GejW84dD/kQDxk6cTVI+BE='
WHERE
key_id = 'c04c00be3f5f25759abf92dab39740bebe8bd5e1f0390d0308515531d4dc8200'
AND (
token = 'igPT6UGkzhy1uFaOQ7m++GejW84dD/kQDxk6cTVI+BE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)