UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FmaPqnARusOK61SQ5j6sr57oQVQ/iu+m8SCeu3/b5EM='
WHERE
key_id = 'f8ab9c3c8e92cc7be458519755ecd228374baf815f067daa0e3fd8146715b1e2'
AND (
token = 'FmaPqnARusOK61SQ5j6sr57oQVQ/iu+m8SCeu3/b5EM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)