UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZ0kiOD7A12+bO+c2hfk45LCyg8CO8LINRhKiO48Wz8='
WHERE
key_id = '0b9dcbaaae5fbdf511a77258fe6b2e43c73c9b52057b5f6701ca046aea10d4ab'
AND (
token = 'dZ0kiOD7A12+bO+c2hfk45LCyg8CO8LINRhKiO48Wz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)