UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0cDfvA8ZBtcSBiiJyzzQEXoJmaDj8q2fXxohK5HY0M='
WHERE
key_id = 'b3843b035aace03fecd1402b597decee00f9f43b6128e92c68a4b5de671d6a6b'
AND (
token = 'I0cDfvA8ZBtcSBiiJyzzQEXoJmaDj8q2fXxohK5HY0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)