UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pAeKZw9VP17fcZWl8vCAFAsHJAD/5SqEgNKJaF3ddcQ='
WHERE
key_id = 'd5b5b43e445d34887482f2289b200cdd671d1f5058f885b3d54445dea27af266'
AND (
token = 'pAeKZw9VP17fcZWl8vCAFAsHJAD/5SqEgNKJaF3ddcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)